CREATE TABLE [dbo].[Service_Request]
(
[ServiceReference] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ServiceReference] DEFAULT (''),
[DateTimeSubmitted] [datetime] NULL,
[SubmitterId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_SubmitterId] DEFAULT (''),
[SubmitterName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_SubmitterName] DEFAULT (''),
[SubmitterCompany] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_SubmitterCompany] DEFAULT (''),
[RecordedBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_RecordedBy] DEFAULT (''),
[LatestResponse] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Title] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Title] DEFAULT (''),
[ServiceType] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ServiceType] DEFAULT (''),
[Area] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Area] DEFAULT (''),
[ImisSystem] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ImisSystem] DEFAULT (''),
[ReleaseNotes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProgramModule] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ProgramModule] DEFAULT (''),
[Description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubmitterPriority] [tinyint] NOT NULL CONSTRAINT [DF_Service_Request_SubmitterPriority] DEFAULT ((0)),
[Category] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Category] DEFAULT (''),
[ProductVersion] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ProductVersion] DEFAULT (''),
[Environment] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Environment] DEFAULT (''),
[Client] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Client] DEFAULT (''),
[Status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Status] DEFAULT (''),
[Priority] [tinyint] NOT NULL CONSTRAINT [DF_Service_Request_Priority] DEFAULT ((0)),
[IsPublic] [bit] NOT NULL CONSTRAINT [DF_Service_Request_IsPublic] DEFAULT ((0)),
[AssignedTo] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_AssignedTo] DEFAULT (''),
[DateTimeAssigned] [datetime] NULL,
[HistoryLog] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProgrammerNotes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateTimeResolved] [datetime] NULL,
[ResolutionCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ResolutionCode] DEFAULT (''),
[ResolvedBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ResolvedBy] DEFAULT (''),
[VersionResolvedIn] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_VersionResolvedIn] DEFAULT (''),
[TestedBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_TestedBy] DEFAULT (''),
[DateTimeTested] [datetime] NULL,
[TestComments] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChangeHistory] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActionRequest] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ActionRequest] DEFAULT (''),
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_INTENT_TO_EDIT] DEFAULT (''),
[IssueReference] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_IssueReference] DEFAULT (''),
[Dev_Status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_Dev_Status] DEFAULT (''),
[CategoryLevel] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_CategoryLevel] DEFAULT (''),
[ContactType] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Service_Request_ContactType] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Service_Request] ADD CONSTRAINT [PK_Service_Request] PRIMARY KEY CLUSTERED ([ServiceReference]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestAssignedTo] ON [dbo].[Service_Request] ([AssignedTo]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestClient] ON [dbo].[Service_Request] ([Client]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestDateTimeSubmit] ON [dbo].[Service_Request] ([DateTimeSubmitted]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestIssueReference] ON [dbo].[Service_Request] ([IssueReference]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestStatus] ON [dbo].[Service_Request] ([Status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestSubmitterCompa] ON [dbo].[Service_Request] ([SubmitterCompany]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestSubmitterId] ON [dbo].[Service_Request] ([SubmitterId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iService_RequestSubmitterName] ON [dbo].[Service_Request] ([SubmitterName]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Service_Request] TO [IMIS]
GRANT SELECT ON  [dbo].[Service_Request] TO [IMIS]
GRANT INSERT ON  [dbo].[Service_Request] TO [IMIS]
GRANT DELETE ON  [dbo].[Service_Request] TO [IMIS]
GRANT UPDATE ON  [dbo].[Service_Request] TO [IMIS]
GO